Use Event.StartOver when you need to make calculations on the data, but don't know the results until all the data has been processed.  In this example, the script calculates the number of children and needs to display a flag for every record (employee + dependent).  It first calculates the number and skips all records, then starts over and emits records.

 

// if this is the first pass and first employee record set counter to 0

if (Event.FirstEmployeeRecord && Event.Globals["SecondPass"] == null)

Event.Globals["Child_Counter"] = 0;

else if (Event.Record["DependentRelationshipID"] > '1' && Event.Globals["SecondPass"] == null) // if not first employee record, then increment counter

Event.Globals["Child_Counter"]++;

// if this is the first pass, skip all records (don't emit records)

if (Event.Globals["SecondPass"] == null)

Event.SkipRecord = true;

if (Event.LastEmployeeRecord)

{

if (Event.Globals["SecondPass"] == null) // if this is the last employee record, set the SecondPass global to true and start over

{

Event.Globals["SecondPass"] = 'True';

Event.StartOver = true; }

else

{

Event.Globals["SecondPass"] = null; // Second pass - set global back to null }

}